Worksheet Import

Data from a wide variety of worksheet formats can be imported into a file, including worksheet data from other programs and worksheets from other VectorWorks files.

Importing Worksheet Data from Another Program

To import a worksheet into the current file, both the worksheet and its original file must be open. In addition, a blank worksheet must exist in the active drawing as a destination for the imported worksheet.

The worksheet formats that can be imported include comma delimited, tab delimited, merge, DIF, and SYLK. During import, the spreadsheet data is imported, but the formulas (logic) are not.

To import a worksheet into VectorWorks:

1.	Create a new worksheet by selecting Window > Palettes > Resource Browser.

The Resource Browser opens.

2.	From the Resources menu, select New Resource to display the New Resource menu.

3.	Select Worksheet.

The Create Worksheet dialog box opens.

4.	Specify the same number of rows and columns that are present in the worksheet to be imported.

5.	Select File > Import > Import Worksheet.

6.	Select the worksheet file to be imported. The worksheet must be in one of the formats available on the Files of type list.

7.	Click Open. The worksheet is imported into the open worksheet in VectorWorks.

Importing Worksheets from Another VectorWorks file

To import a VectorWorks worksheet from another VectorWorks file:

1.	Select Window > Palettes > Resource Browser to open the Resource Browser.

2.	Locate the file containing the worksheet using the Find command in the Resources menu, or from a Favorites file. See Accessing Existing Resources for more information.

3.	Select the worksheet to import, and click Import. (Alternatively, drag the worksheet resource into the desired VectorWorks file to insert it as a drawing object; see Worksheets as Graphic Objects.)

The selected worksheet is imported into the current file.

Importing a Table from Microsoft Word

The following procedure is an example of how to import a table from Microsoft Word into a VectorWorks worksheet.

To import a Word table into a worksheet:

1.	In Word, select the entire table to be imported.

2.	Select Table > Convert > Table to Text.

The Convert Table to Text dialog box opens.

3.	In the dialog box, click Tabs for the separation identifier.

4.

Click OK.

5.	Save the table.

If the file consists of only the table, select File > Save As. In the Save As dialog box that opens, select Text Only from the Save as type list, and click OK.

If the table is part of a larger file, copy the table to the Clipboard. Select File > New, and paste the table text into the new document. Save the file as a text file.

6.	Return to VectorWorks and import the table as described in Importing Worksheet Data from Another Program.